<?php
include 'db.php';
?>


<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
    <title>Bootstrap 101 Template</title>

    <!-- Bootstrap -->
    <link href="./css/bootstrap.min.css" rel="stylesheet">

    <!-- HTML5 shim 和 Respond.js 是为了让 IE8 支持 HTML5 元素和媒体查询（media queries）功能 -->
    <!-- 警告：通过 file:// 协议（就是直接将 html 页面拖拽到浏览器中）访问页面时 Respond.js 不起作用 -->
    <!--[if lt IE 9]>
    <script src="https://cdn.jsdelivr.net/npm/html5shiv@3.7.3/dist/html5shiv.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/respond.js@1.4.2/dest/respond.min.js"></script>
    <![endif]-->
</head>
<body>
<div class="navbar navbar-default" style="margin-bottom:20px">
    <div class="container-fluid">
        <div class="container">
            <div class="navbar-header">
                <span class="navbar-brand">点餐系统</span>
                <ul class="nav navbar-nav">
                    <li class="dropdown">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown">
                            订单管理
                            <span class="caret"></span>
                        </a>
                        <ul class="dropdown-menu">
                            <li><a href="order.php">订单列表</a></li>
                            <li><a href="order2.php">订单记录</a></li>
                        </ul>
                    </li>
                    <li class="dropdown">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown">
                            菜品管理 <span class="caret"></span>
                        </a>
                        <ul class="dropdown-menu">
                            <li><a href="add.php">添加菜品</a></li>
                            <li><a href="add2.php">菜品列表</a></li>
                            <li class="divider"></li>
                            <li><a href="add3.php">添加菜品类型</a></li>
                            <li><a href="add4.php">菜品类型列表</a></li>
                        </ul>
                    </li>
                    <li class="dropdown">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown">
                            餐桌管理
                            <span class="caret"></span>
                        </a>
                        <ul class="dropdown-menu">
                            <li><a href="board.html">添加餐桌</a></li>
                            <li><a href="board2.php">餐桌列表</a></li>
                        </ul>
                    </li>
                    <li class="dropdown">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown">
                            登录管理 <span class="caret"></span>
                        </a>
                        <ul class="dropdown-menu">
                            <li><a href="#" data-toggle="modal" data-target="#aboutModal">关于点餐系统</a></li>
                            <li class="divider"></li>
                            <li><a href="./">修改登录信息</a></li>
                            <li><a href="#" data-toggle="modal">退出登录</a></li>
                        </ul>
                    </li>
                </ul>
            </div>
        </div>
    </div>
</div>

<div class="container">
    <div class="row">
        <div class="col-md-3">
            <a class="btn btn-default btn-block" href="dc.php">返回首页</a>
        </div>
        <div class="col-md-9">
            <div class="panel panel-primary">
                <div class="panel-heading">
                    <h1 class="panel-title">
                        <span class="glyphicon glyphicon-th-list"></span>
                        菜品列表
                    </h1>
                </div>
                <table class="table table-bordered table-hover">
                    <tr>
                        <th>菜品</th>
                        <th>订单</th>
                        <th>价格</th>
                    </tr>
                    <?php
                    $orderId = $_REQUEST['orderId'];
                    $boardId = $_REQUEST['boardId'];
                    $dishId = $_REQUEST['dishId'];
                    $sql = "select * from order_item where order_id=$orderId order by dish_id asc;";
                    $sqlo = $conn->prepare($sql);
                    $ok = $sqlo->execute();
                    $item = $sqlo->fetchAll();


                    // 通过订单Id 获取到订单
                    // 通过获取到的订单 （订单中包含有餐桌id） 里面的餐桌id查询指定餐桌
                    // 获取到餐桌后 显示餐桌名称

                    $sql = "select * from dish_order where id=$orderId";
                    $sqls = $conn->prepare($sql);
                    $ok = $sqls->execute();
                    $qq = $sqls->fetchAll();
                    for($p=0;$p<count($qq);$p++){
                        $board_id=$qq[$p]['board_id'];
                    }

                    $sql="select * from board where id=$board_id";
                    $sqlr=$conn->prepare($sql);
                    $ok=$sqlr->execute();
                    $oo=$sqlr->fetchAll();
                    for ($y=0;$y<count($oo);$y++){
                        $board_name=$oo[$y]['name'];

                    }
                    var_dump($board_name);


                    for ($i = 0; $i < count($item); $i++) {
                        // $item[0]['dish_id']  通过菜品id 查询 指定菜品  显示菜品名字
                         $dish_id=$item[$i]['dish_id'];
                         $sql="select * from dish where id=$dish_id";
                         $sqlp=$conn->prepare($sql);
                         $ok=$sqlp->execute();
                         $list=$sqlp->fetchAll();
                         for ($o=0;$o<count($list);$o++){
                             $dish_name=$list[$o]['dish_name'];
                         }

                        ?>
                        <tr>
                            <td><?php echo $item[$i]['dish_id'] ?></td>
                            <td><?php echo $item[$i]['order_id'] ?></td>
                            <td><?php echo $item[$i]['price'] ?></td>
                        </tr>

                        <?php
                    }
                    ?>
                    <tr style="text-align: center">
                        <td colspan="3"><a href="jz2.php?orderId=<?php echo $orderId;?>" class="btn btn-primary">结账</a></td>
                    </tr>

                </table>
            </div>
        </div>
    </div>

</div>


<!-- jQuery (Bootstrap 的所有 JavaScript 插件都依赖 jQuery，所以必须放在前边) -->
<script src="./js/jquery.min.js"></script>
<!-- 加载 Bootstrap 的所有 JavaScript 插件。你也可以根据需要只加载单个插件。 -->
<script src="./js/bootstrap.min.js"></script>
</body>
</html>